﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DbAccessLib;
using System.Data;
using System.Data.OleDb;

namespace DataAccess
{
    public class DichVuDAO
    {
        static private DichVuDAO m_DAO = new DichVuDAO();

        static public DichVuDAO DAO
        {
            get { return m_DAO; }
        }

        private DichVuDAO()
        {
        }

        public DataTable layDanhSachDichVu()
        {
            String CommandText = " SELECT MaDichVu , TenDichVu FROM DICHVU ORDER BY TenDichVu; ";

            SQLStatement cmd = Db.DiaDiemDB.CreateStatement(CommandText);

            return cmd.ExecuteQuery();
        }
    }
}
